The iMIS cube in the analysis database contains the following dimensions and measures. If you use the recommended ProClarity Professional OLAP viewer with iMIS Analytics, you can easily browse the dimensions and measures and create any needed view of your iMIS business performance. Once you have created a custom view (see Viewing the iMIS cube for ad-hoc analysis), you can add it to the predefined views in the Analytics Briefing Book.
Dimensions
■ Campaign
■ Channel
■ Customer
■ Customer Ext Dim (see Configuring Analytics to track custom iMIS demographics)
■ Date
■ GL Account
■ Group Enroll Type
■ Group Expire Type
■ Group
■ Issue Status
■ Issue Type
■ Opportunity Status
■ Opportunity Type
■ Organization
■ Product
■ Promotion
■ Response Media
■ Sales Location
■ Sales Order Details
■ Sales Team
■ Shipper
■ Warehouse
Measure groups (facts) and measures
■ GL Transaction Fact
□ GL Transaction Fact Count
□ Transaction Amount
■ Group Enrollment Fact
□ Count
□ Group Enrollment Fact Count
■ Group Stats Fact
□ Active Count
□ Downgrade
□ Dropped
□ Lapsed
□ New
□ Reinstate
□ Renew
□ Transfer In
□ Transfer Out
□ Upgrade
■ Inventory Level Fact
□ Cost
□ Inventory Level Fact Count
□ Quantity On Hand
□ Quantity On Order
□ Quantity Received
□ Quantity Shipped
□ Quantity Sold
■ Issue Fact
□ Issue Fact Count
□ Service Provider Key
□ Time to Resolve
□ Total Effort
■ Opportunity Fact
□ Component Price1
□ Component Price2
□ Component Price3
□ List Price
□ Opportunity Fact Count
□ Probability
□ Purchase Budget
□ Units
■ Pledge Fact
□ Adjustment Amount
□ Amount Paid
□ Open Balance
□ Pledge Amount
□ Pledge Fact Count
■ Sales Fact
□ Cost Amount
□ Fair Market Value
□ Gross Profit
□ Quantity
□ Sales Amount
□ Sales Fact Count